﻿CREATE TABLE [dbo].[Addresses]
(
    [Id] UNIQUEIDENTIFIER NOT NULL PRIMARY KEY DEFAULT newid(), 
    [AddressLine1] NVARCHAR(30) NOT NULL, 
    [AddressLine2] NVARCHAR(30) NULL, 
    [AddressLine3] NVARCHAR(30) NULL, 
    [City] NVARCHAR(20) NOT NULL, 
    [State] NCHAR(2) NOT NULL, 
    [ZipCode] NCHAR(10) NOT NULL, 
    [DateCreated] DATETIME NOT NULL DEFAULT GetDate(), 
    [DateModified] DATETIME NOT NULL DEFAULT GetDate(), 
    [DateDeleted] DATETIME NULL
)
